www.gusucode.com > PHP展示型企业网站模板米拓整站源码 1.0PHP源码程序 > PHP展示型企业网站模板米拓整站源码 1.0/MetInfozs_v1.0/MetInfozs_v1.0/admin/app/batch/csv.php
<?php # MetInfo Enterprise Content Management System # Copyright (C) MetInfo Co.,Ltd (http://www.metinfo.cn). All rights reserved. $depth='../'; require_once $depth.'../login/login_check.php'; include $depth."../include/pclzip.lib.php"; $codeold='utf-8'; $codenew='GBK'; $class=$class3?$class3:($class2?$class2:$class1); $classcsv=$db->get_one("select * from $met_column where id='$class'"); $class1title=$db->get_one("select * from $met_column where id='$class1'"); if($class2){$class2title=$db->get_one("select * from $met_column where id='$class2'");} if($class3){$class3title=$db->get_one("select * from $met_column where id='$class3'");} $title=$class1title[name]; $title.=$class2?"_$class2title[name]":""; $title.=$class3?"_$class3title[name]":""; $title.="_$class1title[id]"; $title.=$class2?"-$class2title[id]":""; $title.=$class3?"-$class3title[id]":""; $title=str_replace('/','',$title); $title=str_replace('\\','',$title); $title=str_replace('<','',$title); $title=str_replace('>','',$title); $title=str_replace('?','',$title); $title=str_replace('|','',$title); $title=str_replace('*','',$title); $title=str_replace(':','',$title); $title=str_replace('"','',$title); $title=iconv($codeold,$codenew,$title); $fp = fopen("$title.csv", 'w'); $classcsv=$class3?$class3title:($class2?$class2title:$class1title); $csvarray[]=iconv($codeold,$codenew,$lang_title); if($classcsv['module']!=2){ $query = "select * from $met_parameter where lang='$lang' and module='$classcsv[module]' and (class1='0' or (class1='$class1' and class2='$class2' and class3=0) or (class1='$class1' and class2='$class2' and class3='$class3') or (class1='$class1' and class2=0 and class3=0)) order by no_order"; $csvpara=$db->get_all($query); foreach($csvpara as $key=>$val){ if($val['type']!=5){$csvarray[]=iconv($codeold,$codenew,$val['name']);} } } $csvarray[]=iconv($codeold,$codenew,$lang_columnhtmlname); $csvarray[]=iconv($codeold,$codenew,$lang_columnmtitle); $csvarray[]=iconv($codeold,$codenew,$lang_keywords); $csvarray[]=iconv($codeold,$codenew,$lang_description); $csvarray[]=iconv($codeold,$codenew,$lang_contentdetail); $metadminnum=0; if($metadmin['productother']&&$classcsv['module']==3){ $metadminnum=$metadmin['productother']; } if($metadmin['imgother']&&$classcsv['module']==5){ $metadminnum=$metadmin['imgother']; } if($metadminnum!=0){ $cvsother=1; while($cvsother<=$metadminnum){ $contentinfo=$lang_contentinfo.$cvsother; $csvarray[]=iconv($codeold,$codenew,$contentinfo); $cvsother++; } } fputcsv($fp,$fristarray); fputcsv($fp,$csvarray); fclose($fp); $sqlzip='csv.zip'; $archive = new PclZip($sqlzip); $zip_list = $archive->create("./$title.csv"); $cont = iconv($codeold,$codenew,"{$lang_csvexplain1}\r\n{$lang_csvexplain2}\r\n{$lang_csvexplain3}\r\n{$lang_csvexplain4}"); $fp = fopen(iconv($codeold,$codenew,"./{$lang_langshuom}.txt"),w); fputs($fp, $cont); fclose($fp); $zip_list = $archive->add(iconv($codeold,$codenew,"./{$lang_langshuom}.txt")); @file_unlink("./$title.csv"); @file_unlink(iconv($codenew,$codeold,"./$title.csv")); @file_unlink(iconv($codeold,$codenew,"./{$lang_langshuom}.txt")); header("Content-type:application/zip;"); $title=$title.'.zip'; $title=iconv($codenew,$codeold,$title); $encoded_filename = urlencode($title); $encoded_filename = str_replace("+", "%20", $encoded_filename); $ua = $_SERVER["HTTP_USER_AGENT"]; if (preg_match("/MSIE/", $ua)) { header('Content-Disposition: attachment; filename="' . $encoded_filename . '"'); } else if (preg_match("/Firefox/", $ua)) { header('Content-Disposition: attachment; filename="' . $title . '"'); } else { header('Content-Disposition: attachment; filename="' . $title . '"'); } readfile("csv.zip"); @file_unlink("csv.zip"); # This program is an open source system, commercial use, please consciously to purchase commercial license. # Copyright (C) MetInfo Co., Ltd. (http://www.metinfo.cn). All rights reserved. ?>